CustomerAccountPaymentAccount

Entity Definition

Logical Name : CustomerAccountPaymentAccount
Physical Name : LE_ENCRYPTD_CT_PYM_ACNT

This is a stored customer account default payment account intended to enable customers to easily pay for ordered items without having to reenger account numbers, names, addresses, etc. As modeled here it is NOT a retailer "owned" customer account which is why it is not a subtype of CustomerAccount. It is a typical credit or debit account that reflects a finanical arrangement between the customer and the financial insitution that issued the credit/debit card. This is included in the data model primarily to reflect the practice of retaining payment methods along with customer accounts (e.g. like Amazon and other ecommerc businesses). This information may physically be gathered and stored by third parties for PCI compliance purposes. This data, if persisted by the retailer, MUST BE ENCRYPTED AND SECURED IN COMPLIANCE WITH PCI SPECIFICATIONS. The attributes shown here refelct the type of information held in a secured default payment entity.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
PaymentAccountSequence (PK) A sequence number to distinguish between payment accounts tied to a CustomerAccount. A value of 1 is always used to indicate the PRIMARY, default account. AI_PYM_ACNT_SQN LineNumber smallint
CreditDeibitCardTypeCode A code denoting which kind of card is being accepted. Sample values include: DEBIT CREDIT EBT FLEET OTHER TY_CRD Code6 char(6)
CardIssuerCode The first six digits from the Credit/Debit card. It identifies the bank or other financial institution that issued the debit/credit card used in the transaction. ID_ISSR_TND_CRD Code6 char(6)
AccountNumber The account number appearing on a debit/credit card and identifying the card issuer's customer account to be charged or credited for the transaction. This information must be encrypted. ID_ACNT_DB_CR_CRD Name varchar(40)
Track1CreditCardBitMap Defines the bit pattern used on track 1 of the magnetic strip on the back of a credit card. DE_TRCK_1_BT_MP BitMap binary(128)
Track2CreditCardBitMap Defines the bit pattern used on track 2 of the magnetic strip on the back of a credit card. DE_TRCK_2_BT_MP BitMap binary(128)
Track3CreditCardBitMap Defines the bit pattern used on track 3 of the magnetic strip on the back of a credit card. DE_TRCK_3_BT BitMap binary(128)
Track4CreditCardBitMap Defines the bit pattern used on track 4 of the magnetic strip on the back of a credit card. BM_CR_CRD_TRK_4 BitMap binary(128)
CardExpirationDate The expiration date of the Credit or Debit card, as taken from the card in MMYY format. DC_EP_CRD Code4 char(4)
CardHolderName The name of the cardholder, as taken from the card. NM_CRD_HLD Name varchar(40)
CardIssuerSequenceNumber The IssueSequnce number of the credit card being used assigned by the Credit/Debit Card issuer. AI_CRD_ISS Identity integer
CardStartDate The commencement date of the Credit or Debit card, as taken from the card in MMYY format. DT_CRD_SRT Code4 char(4)
ServiceCode The value of the service field from the card. In XML this is referred to as a SecurityCode. The names vary from one credit debit card provider to another. Both are the same thing - a 3-4 digit code used to validate a card at the POS. CD_SV Code4 char(4)
ReconciliationCode A code used to indicate if thie credit/debit card instance is reconciled or not. CD_RCN Identity integer
StatusCode Indiates the status of this designated customer account payment account. Valid values are: A - Active N - Activated but not used C - Canceled S - Suspended CD_STS Code2Status char(2)
EffectiveDate The date an EncryptedCustomerAccountPaymentAccount becomes active. DC_EF_DT EffectiveDateTime datetime
ExpirationDate The date an EncryptedCustomerAccountPaymentAccount becomes inactive. DC_EP_DT ExpirationDate date

Relationships

Parent Entity Verb Phrase Child Entity
CustomerAccount may be paid for by CustomerAccountPaymentAccount

Logical Views containing CustomerAccountPaymentAccount

Logical View
Logical 07010 - Customer Account Information Extended